Use this query to create Job Services based upon a single Job Service: Insert Into [JobService] ([DBId], [Id], [JobId], [ServiceId], [Num], [Description], [DescriptionExcess], [ClientId], [FeeType], [FeeTypeTrigger], [Fees], [ACFees], [Limit], [IndexValue], [IndexArticleId], [IndexCalcAmount], [YearlyCyAmount], [YearlyIndexCalcAmount], [CommissionArticleId], [CommissionRate], [CommissionAmount], [CommissionACAmount], [IncludeInInvoice], [Frequency], [FrequencyNum], [FrequencyType], [FrequencyDate], [RepeatMonth], [RepeatNumber], [TimeReportTypeId], [NumberOfUnits], [StartDate], [EndDate], [CurrencyId], [ACCurrencyId], [GLAccountId], [VATId], [VATCode], [VATRate], … Continue reading Query to create Job Services based upon Job Service